package com.example.springboot005tx.provider;

import com.example.springboot005tx.pojo.User;

/**
 * @description: TODO
 * @author: uu
 * @data: 2023/6/18 21:04
 * @version: v1.0
 */
public class UserProvider {
    public static String selectById(Integer id){
        return """
                select * from t_user where id = #{id};
                """;
    }

    public static String selectAll(){
        return """
                select * form t_user;
                """;
    }

    public static String insert(User user){
        return """
                insert into t_user values(null,#{username},#{password},#{phone});
                """;
    }
}
